/* 

CREATE TABLE lottery.l_bingo (
	b_uid varchar (40) ,
	b_code varchar (50) ,
	b_title varchar (200) ,
	b_author varchar (50) ,
	b_date date,
	b_content varchar (500) ,
	b_sign_begin timestamp ,
	b_sign_end timestamp ,
	b_attend_begin timestamp ,
	b_attend_end timestamp ,
	b_desc varchar (150) ,
	
	PRIMARY KEY (b_uid)
)

 */

import { Entity, PrimaryColumn, Column } from "typeorm";

@Entity({ schema: "lottery", name: "l_bingo" })
export class BingoEntity {

    @PrimaryColumn({name: "b_uid", type: "varchar", length: 40 })
	//@Generated("uuid")
    id: string;

    @Column({name: "b_code", type: "varchar", length: 20 })
    code: string;

    @Column({name: "b_title", type: "varchar", length: 100, nullable: true })
    title: string;

    @Column({name: "b_author", type: "varchar", length: 50, nullable: true })
    author: string;

    @Column({name: "b_date", type: "date", nullable: true })
    date: Date;
	
	@Column({name: "b_content", type: "varchar", length: 500, nullable: true })
	content: string;
	

    @Column({name: "b_sign_begin", type: "timestamp", nullable: true })
    signBegin: Date;

    @Column({name: "b_sign_end", type: "timestamp", nullable: true })
    signEnd: Date;
	

    @Column({name: "b_attend_begin", type: "timestamp", nullable: true })
    attendBegin: Date;

    @Column({name: "b_attend_end", type: "timestamp", nullable: true })
    attendEnd: Date;
	
	@Column({name: "b_current", type: "boolean", nullable: true })
	current: boolean;
	
	
	@Column({name: "b_desc", type: "varchar", length: 150, nullable: true })
	desc: string;

}
